#商品访问次数1天7天30天统计表导出
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd10_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_spu_visit \
--export-dir /warehouse/page/ads/ads_spu_visit/ds=20250729 \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

#店铺访问次数1天7天30天统计表导出
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd10_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_shop_visit \
--export-dir /warehouse/page/ads/ads_shop_visit/ds=20250729 \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


#板块访问次数1天7天30天统计表导出
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd10_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_section_visit \
--export-dir /warehouse/page/ads/ads_section_visit/ds=20250729 \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


#商品访问占板块访问比例1天7天30天统计表导出
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd10_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_section_spu_ratio \
--export-dir /warehouse/page/ads/ads_section_spu_ratio/ds=20250729 \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


#板块访问占店铺访问比例1天7天30天统计表导出
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd10_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_shop_section_ratio \
--export-dir /warehouse/page/ads/ads_shop_section_ratio/ds=20250729 \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


#店铺访问平均停留时长1天7天30天统计表导出
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/jtp_gd10_warehouse?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_shop_avg_stay \
--export-dir /warehouse/page/ads/ads_shop_avg_stay/ds=20250729 \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

